<?php

$installer = $this;

$installer->startSetup();

$installer->run("
    DROP TABLE IF EXISTS {$this->getTable('managecatalog_spr')};
    CREATE TABLE {$this->getTable('managecatalog_spr')} (
      `managecatalog_id` int(11) unsigned NOT NULL auto_increment,
      `title` varchar(255) NOT NULL default '',
      `filename` varchar(255) NOT NULL default '',
      `content` text, 
      `status` smallint(6) NOT NULL default '0',
      `created_time` datetime NULL,
      `update_time` datetime NULL,
      `success` int(10) default NULL,
      `fail` int(10) default NULL,
      `total` int(10) default NULL,
       PRIMARY KEY (`managecatalog_id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

");


$installer->endSetup(); 